home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
kermit.columbia.edu
/
kermit.columbia.edu.tar
/
kermit.columbia.edu
/
newsgroups
/
misc.19950528-19950726
/
000077_news@columbia.edu_Tue Jun 6 19:40:33 1995.msg
< prev
next >
Wrap
Internet Message Format
|
1995-07-31
|
3KB
Received: from apakabar.cc.columbia.edu by watsun.cc.columbia.edu with SMTP id AA06884
(5.65c+CU/IDA-1.4.4/HLK for <kermit.misc@watsun.cc.columbia.edu>); Tue, 6 Jun 1995 20:45:33 -0400
Received: by apakabar.cc.columbia.edu id AA18079
(5.65c+CU/IDA-1.4.4/HLK for kermit.misc@watsun); Tue, 6 Jun 1995 20:45:31 -0400
Path: news.columbia.edu!panix!bloom-beacon.mit.edu!news.kei.com!news.mathworks.com!gatech!news.sprintlink.net!malgudi.oar.net!cmhcsys.cmhcsys.com!chuck
From: chuck@cmhcsys.com (Chuck Stickelman)
Newsgroups: comp.protocols.kermit.misc
Subject: Kermit as data-entry clerk
Date: 6 Jun 1995 19:40:33 GMT
Organization: CMHC Systems, Dublin, Ohio
Lines: 57
Message-Id: <3r2avh$cdm@cmhcsys.cmhcsys.com>
Nntp-Posting-Host: news.cmhcsys.com
Summary: Using kermit to eliminate data-entry redundancy
Keywords: kermit variables
X-Newsreader: TIN [UNIX 1.3 950515BETA PL0]
X-Newsreader: TIN [version 1.2 PL2]
Apparently-To: kermit.misc@watsun.cc.columbia.edu
Howdy all,
I'll start w/ a little background:
We have a customer how needs to get information from our proprietary
database into a county-wide system. Unfortunately, the county-wide
system does not allow batch transfers of any kind. Therefore, the
customer has been paying a full-time employee to run a couple of
reports on our system and then re-key the data into the other database.
Needless to say, this is less than ideal.
I proposed that we output the data to a DOS file in a format Kermit
would like: {field data }{more field data }{even more...} etc.
No problem. Then I thought we could use Kermit's 'read', 'assign'
and 'output' commands to fake the remote system into thinking a real
-live human was on the other end. Something like:
define parse assign \%a \%1, assign \%b \%2, assign \%c \%3, ...
open somefile.dat
read \%z
parse \%z
output \%a
output \%b
output \%c
...
However, the records in somefile.dat have too many fields (>35 in one
instance) and I'm running out of both temporary and permanent variables.
I've read the relevant pages in "Using MS-KERMIT" and understand that
there are 10 temporary variables (0-9) and 26 permanent variables (a-z),
but wonder if there's anyway I can "easily" change that or get around
those limitations!?
I'm open to ideas, comments or what-ever. I don't expect anyone else to
code this for me, just looking for different perspectives.
FWIW, I've considered breaking the records into multiple lines for the
read command, but I think this will make the whole process much more
fragile than it already is...
Thanks
Chuck
--
Charles A. Stickelman <chuck@cmhcsys.com>
PC Sales Engineer
CMHC Systems, Inc. Work: (614) 764-0143
570 Metro Place North Sales: (800) 528-9025
Dublin, OH 43017 USA FAX: (614) 764-0439
--
--
Charles A. Stickelman <chuck@cmhcsys.com>
PC Sales Engineer
CMHC Systems, Inc. Work: (614) 764-0143
570 Metro Place North Sales: (800) 528-9025
Dublin, OH 43017 USA FAX: (614) 764-0439
--